﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Policies" targetNamespace="http://tempuri.org/Policies.xsd" xmlns:mstns="http://tempuri.org/Policies.xsd" xmlns="http://tempuri.org/Policies.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="RundConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="RundConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.RundConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="LonsdaleConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LonsdaleConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.LonsdaleConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PoliciesTableAdapter" GeneratorDataComponentClassName="PoliciesTableAdapter" Name="Policies" UserDataComponentName="PoliciesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LonsdaleConnectionString (MySettings)" DbObjectName="Lonsdale.dbo.Policies" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [Policies] WHERE (([SNo] = @Original_SNo) AND ((@IsNull_PESno = 1 AND [PESno] IS NULL) OR ([PESno] = @Original_PESno)) AND ((@IsNull_PESSNo = 1 AND [PESSNo] IS NULL) OR ([PESSNo] = @Original_PESSNo)) AND ((@IsNull_ClientNo = 1 AND [ClientNo] IS NULL) OR ([ClientNo] = @Original_ClientNo)) AND ((@IsNull_ClientName = 1 AND [ClientName] IS NULL) OR ([ClientName] = @Original_ClientName)) AND ((@IsNull_Producer = 1 AND [Producer] IS NULL) OR ([Producer] = @Original_Producer)) AND ((@IsNull_AccNo = 1 AND [AccNo] IS NULL) OR ([AccNo] = @Original_AccNo)) AND ((@IsNull_PolicyNo = 1 AND [PolicyNo] IS NULL) OR ([PolicyNo] = @Original_PolicyNo)) AND ((@IsNull_EndorsNo = 1 AND [EndorsNo] IS NULL) OR ([EndorsNo] = @Original_EndorsNo)) AND ((@IsNull_EndorsType = 1 AND [EndorsType] IS NULL) OR ([EndorsType] = @Original_EndorsType)) AND ((@IsNull_InsurComp = 1 AND [InsurComp] IS NULL) OR ([InsurComp] = @Original_InsurComp)) AND ((@IsNull_IssueDate = 1 AND [IssueDate] IS NULL) OR ([IssueDate] = @Original_IssueDate)) AND ((@IsNull_ClassName = 1 AND [ClassName] IS NULL) OR ([ClassName] = @Original_ClassName)) AND ((@IsNull_InterestInsur = 1 AND [InterestInsur] IS NULL) OR ([InterestInsur] = @Original_InterestInsur)) AND ((@IsNull_PeriodFrom = 1 AND [PeriodFrom] IS NULL) OR ([PeriodFrom] = @Original_PeriodFrom)) AND ((@IsNull_PeriodTo = 1 AND [PeriodTo] IS NULL) OR ([PeriodTo] = @Original_PeriodTo)) AND ((@IsNull_RenewDate = 1 AND [RenewDate] IS NULL) OR ([RenewDate] = @Original_RenewDate)) AND ((@IsNull_PaidAmount = 1 AND [PaidAmount] IS NULL) OR ([PaidAmount] = @Original_PaidAmount)) AND ((@IsNull_SumInsur = 1 AND [SumInsur] IS NULL) OR ([SumInsur] = @Original_SumInsur)) AND ((@IsNull_TotalPremium = 1 AND [TotalPremium] IS NULL) OR ([TotalPremium] = @Original_TotalPremium)) AND ((@IsNull_NetPremium = 1 AND [NetPremium] IS NULL) OR ([NetPremium] = @Original_NetPremium)) AND ((@IsNull_CompComm = 1 AND [CompComm] IS NULL) OR ([CompComm] = @Original_CompComm)) AND ((@IsNull_ProducerComm = 1 AND [ProducerComm] IS NULL) OR ([ProducerComm] = @Original_ProducerComm)) AND ((@IsNull_CompCommPerc = 1 AND [CompCommPerc] IS NULL) OR ([CompCommPerc] = @Original_CompCommPerc)) AND ((@IsNull_ProducerCommPerc = 1 AND [ProducerCommPerc] IS NULL) OR ([ProducerCommPerc] = @Original_ProducerCommPerc)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)) AND ((@IsNull_SavedDate = 1 AND [SavedDate] IS NULL) OR ([SavedDate] = @Original_SavedDate)) AND ((@IsNull_SavedUser = 1 AND [SavedUser] IS NULL) OR ([SavedUser] = @Original_SavedUser)) AND ((@IsNull_ApprovedDate = 1 AND [ApprovedDate] IS NULL) OR ([ApprovedDate] = @Original_ApprovedDate)) AND ((@IsNull_ApprovedUser = 1 AND [ApprovedUser] IS NULL) OR ([ApprovedUser] = @Original_ApprovedUser)) AND ((@IsNull_Department = 1 AND [Department] IS NULL) OR ([Department] = @Original_Department)) AND ((@IsNull_Done = 1 AND [Done] IS NULL) OR ([Done] = @Original_Done)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PESno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PESno" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PESSNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PESSNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Producer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Producer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolicyNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndorsNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EndorsNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndorsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EndorsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InsurComp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InsurComp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IssueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_IssueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClassName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClassName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InterestInsur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InterestInsur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodFrom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PeriodFrom" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PeriodTo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RenewDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RenewDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaidAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PaidAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SumInsur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SumInsur" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPremium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NetPremium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_NetPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CompComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProducerComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ProducerComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompCommPerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CompCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProducerCommPerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ProducerCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SavedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Department" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Department" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [Policies] ([PESno], [PESSNo], [ClientNo], [ClientName], [Producer], [AccNo], [PolicyNo], [EndorsNo], [EndorsType], [InsurComp], [IssueDate], [ClassName], [InterestInsur], [PeriodFrom], [PeriodTo], [RenewDate], [PaidAmount], [SumInsur], [TotalPremium], [NetPremium], [CompComm], [ProducerComm], [CompCommPerc], [ProducerCommPerc], [TransDate], [SavedDate], [SavedUser], [ApprovedDate], [ApprovedUser], [Department], [Done]) VALUES (@PESno, @PESSNo, @ClientNo, @ClientName, @Producer, @AccNo, @PolicyNo, @EndorsNo, @EndorsType, @InsurComp, @IssueDate, @ClassName, @InterestInsur, @PeriodFrom, @PeriodTo, @RenewDate, @PaidAmount, @SumInsur, @TotalPremium, @NetPremium, @CompComm, @ProducerComm, @CompCommPerc, @ProducerCommPerc, @TransDate, @SavedDate, @SavedUser, @ApprovedDate, @ApprovedUser, @Department, @Done);
SELECT SNo, PESno, PESSNo, ClientNo, ClientName, Producer, AccNo, PolicyNo, EndorsNo, EndorsType, InsurComp, IssueDate, ClassName, InterestInsur, PeriodFrom, PeriodTo, RenewDate, PaidAmount, SumInsur, TotalPremium, NetPremium, CompComm, ProducerComm, CompCommPerc, ProducerCommPerc, TransDate, SavedDate, SavedUser, ApprovedDate, ApprovedUser, Department, Done FROM Policies WHERE (SNo = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PESno" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PESSNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Producer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EndorsNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EndorsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsurComp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IssueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClassName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InterestInsur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PeriodFrom" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PeriodTo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RenewDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PaidAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SumInsur" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@NetPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CompComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ProducerComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CompCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ProducerCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SavedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Department" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SNo, PESno, PESSNo, ClientNo, ClientName, Producer, AccNo, PolicyNo, EndorsNo, EndorsType, InsurComp, IssueDate, ClassName, InterestInsur, PeriodFrom, PeriodTo, RenewDate, PaidAmount, SumInsur, TotalPremium, NetPremium, CompComm, ProducerComm, CompCommPerc, ProducerCommPerc, TransDate, SavedDate, SavedUser, ApprovedDate, ApprovedUser, Department, Done FROM Policies</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [Policies] SET [PESno] = @PESno, [PESSNo] = @PESSNo, [ClientNo] = @ClientNo, [ClientName] = @ClientName, [Producer] = @Producer, [AccNo] = @AccNo, [PolicyNo] = @PolicyNo, [EndorsNo] = @EndorsNo, [EndorsType] = @EndorsType, [InsurComp] = @InsurComp, [IssueDate] = @IssueDate, [ClassName] = @ClassName, [InterestInsur] = @InterestInsur, [PeriodFrom] = @PeriodFrom, [PeriodTo] = @PeriodTo, [RenewDate] = @RenewDate, [PaidAmount] = @PaidAmount, [SumInsur] = @SumInsur, [TotalPremium] = @TotalPremium, [NetPremium] = @NetPremium, [CompComm] = @CompComm, [ProducerComm] = @ProducerComm, [CompCommPerc] = @CompCommPerc, [ProducerCommPerc] = @ProducerCommPerc, [TransDate] = @TransDate, [SavedDate] = @SavedDate, [SavedUser] = @SavedUser, [ApprovedDate] = @ApprovedDate, [ApprovedUser] = @ApprovedUser, [Department] = @Department, [Done] = @Done WHERE (([SNo] = @Original_SNo) AND ((@IsNull_PESno = 1 AND [PESno] IS NULL) OR ([PESno] = @Original_PESno)) AND ((@IsNull_PESSNo = 1 AND [PESSNo] IS NULL) OR ([PESSNo] = @Original_PESSNo)) AND ((@IsNull_ClientNo = 1 AND [ClientNo] IS NULL) OR ([ClientNo] = @Original_ClientNo)) AND ((@IsNull_ClientName = 1 AND [ClientName] IS NULL) OR ([ClientName] = @Original_ClientName)) AND ((@IsNull_Producer = 1 AND [Producer] IS NULL) OR ([Producer] = @Original_Producer)) AND ((@IsNull_AccNo = 1 AND [AccNo] IS NULL) OR ([AccNo] = @Original_AccNo)) AND ((@IsNull_PolicyNo = 1 AND [PolicyNo] IS NULL) OR ([PolicyNo] = @Original_PolicyNo)) AND ((@IsNull_EndorsNo = 1 AND [EndorsNo] IS NULL) OR ([EndorsNo] = @Original_EndorsNo)) AND ((@IsNull_EndorsType = 1 AND [EndorsType] IS NULL) OR ([EndorsType] = @Original_EndorsType)) AND ((@IsNull_InsurComp = 1 AND [InsurComp] IS NULL) OR ([InsurComp] = @Original_InsurComp)) AND ((@IsNull_IssueDate = 1 AND [IssueDate] IS NULL) OR ([IssueDate] = @Original_IssueDate)) AND ((@IsNull_ClassName = 1 AND [ClassName] IS NULL) OR ([ClassName] = @Original_ClassName)) AND ((@IsNull_InterestInsur = 1 AND [InterestInsur] IS NULL) OR ([InterestInsur] = @Original_InterestInsur)) AND ((@IsNull_PeriodFrom = 1 AND [PeriodFrom] IS NULL) OR ([PeriodFrom] = @Original_PeriodFrom)) AND ((@IsNull_PeriodTo = 1 AND [PeriodTo] IS NULL) OR ([PeriodTo] = @Original_PeriodTo)) AND ((@IsNull_RenewDate = 1 AND [RenewDate] IS NULL) OR ([RenewDate] = @Original_RenewDate)) AND ((@IsNull_PaidAmount = 1 AND [PaidAmount] IS NULL) OR ([PaidAmount] = @Original_PaidAmount)) AND ((@IsNull_SumInsur = 1 AND [SumInsur] IS NULL) OR ([SumInsur] = @Original_SumInsur)) AND ((@IsNull_TotalPremium = 1 AND [TotalPremium] IS NULL) OR ([TotalPremium] = @Original_TotalPremium)) AND ((@IsNull_NetPremium = 1 AND [NetPremium] IS NULL) OR ([NetPremium] = @Original_NetPremium)) AND ((@IsNull_CompComm = 1 AND [CompComm] IS NULL) OR ([CompComm] = @Original_CompComm)) AND ((@IsNull_ProducerComm = 1 AND [ProducerComm] IS NULL) OR ([ProducerComm] = @Original_ProducerComm)) AND ((@IsNull_CompCommPerc = 1 AND [CompCommPerc] IS NULL) OR ([CompCommPerc] = @Original_CompCommPerc)) AND ((@IsNull_ProducerCommPerc = 1 AND [ProducerCommPerc] IS NULL) OR ([ProducerCommPerc] = @Original_ProducerCommPerc)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)) AND ((@IsNull_SavedDate = 1 AND [SavedDate] IS NULL) OR ([SavedDate] = @Original_SavedDate)) AND ((@IsNull_SavedUser = 1 AND [SavedUser] IS NULL) OR ([SavedUser] = @Original_SavedUser)) AND ((@IsNull_ApprovedDate = 1 AND [ApprovedDate] IS NULL) OR ([ApprovedDate] = @Original_ApprovedDate)) AND ((@IsNull_ApprovedUser = 1 AND [ApprovedUser] IS NULL) OR ([ApprovedUser] = @Original_ApprovedUser)) AND ((@IsNull_Department = 1 AND [Department] IS NULL) OR ([Department] = @Original_Department)) AND ((@IsNull_Done = 1 AND [Done] IS NULL) OR ([Done] = @Original_Done)));
SELECT SNo, PESno, PESSNo, ClientNo, ClientName, Producer, AccNo, PolicyNo, EndorsNo, EndorsType, InsurComp, IssueDate, ClassName, InterestInsur, PeriodFrom, PeriodTo, RenewDate, PaidAmount, SumInsur, TotalPremium, NetPremium, CompComm, ProducerComm, CompCommPerc, ProducerCommPerc, TransDate, SavedDate, SavedUser, ApprovedDate, ApprovedUser, Department, Done FROM Policies WHERE (SNo = @SNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PESno" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PESSNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Producer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EndorsNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@EndorsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InsurComp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@IssueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ClassName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@InterestInsur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PeriodFrom" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@PeriodTo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@RenewDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PaidAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@SumInsur" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@NetPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CompComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ProducerComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@CompCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@ProducerCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@SavedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Department" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PESno" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PESno" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESno" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PESSNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PESSNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PESSNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_ClientNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="ClientNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClientName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClientName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Producer" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Producer" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Producer" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolicyNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolicyNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolicyNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndorsNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EndorsNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndorsType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_EndorsType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="EndorsType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InsurComp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InsurComp" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InsurComp" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IssueDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_IssueDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="IssueDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClassName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ClassName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ClassName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InterestInsur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_InterestInsur" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="InterestInsur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodFrom" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PeriodFrom" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodFrom" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PeriodTo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_PeriodTo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="PeriodTo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RenewDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_RenewDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="RenewDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaidAmount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_PaidAmount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PaidAmount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SumInsur" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_SumInsur" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="SumInsur" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalPremium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalPremium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NetPremium" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_NetPremium" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="NetPremium" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CompComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompComm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProducerComm" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ProducerComm" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerComm" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CompCommPerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_CompCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="CompCommPerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProducerCommPerc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_ProducerCommPerc" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="ProducerCommPerc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_SavedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="SavedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Department" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Department" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Department" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Done" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Done" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SNo" ColumnName="SNo" DataSourceName="Lonsdale.dbo.Policies" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SNo" DataSetColumn="SNo" />
              <Mapping SourceColumn="PESno" DataSetColumn="PESno" />
              <Mapping SourceColumn="PESSNo" DataSetColumn="PESSNo" />
              <Mapping SourceColumn="ClientNo" DataSetColumn="ClientNo" />
              <Mapping SourceColumn="ClientName" DataSetColumn="ClientName" />
              <Mapping SourceColumn="Producer" DataSetColumn="Producer" />
              <Mapping SourceColumn="AccNo" DataSetColumn="AccNo" />
              <Mapping SourceColumn="PolicyNo" DataSetColumn="PolicyNo" />
              <Mapping SourceColumn="EndorsNo" DataSetColumn="EndorsNo" />
              <Mapping SourceColumn="EndorsType" DataSetColumn="EndorsType" />
              <Mapping SourceColumn="InsurComp" DataSetColumn="InsurComp" />
              <Mapping SourceColumn="IssueDate" DataSetColumn="IssueDate" />
              <Mapping SourceColumn="ClassName" DataSetColumn="ClassName" />
              <Mapping SourceColumn="InterestInsur" DataSetColumn="InterestInsur" />
              <Mapping SourceColumn="PeriodFrom" DataSetColumn="PeriodFrom" />
              <Mapping SourceColumn="PeriodTo" DataSetColumn="PeriodTo" />
              <Mapping SourceColumn="RenewDate" DataSetColumn="RenewDate" />
              <Mapping SourceColumn="PaidAmount" DataSetColumn="PaidAmount" />
              <Mapping SourceColumn="SumInsur" DataSetColumn="SumInsur" />
              <Mapping SourceColumn="TotalPremium" DataSetColumn="TotalPremium" />
              <Mapping SourceColumn="NetPremium" DataSetColumn="NetPremium" />
              <Mapping SourceColumn="CompComm" DataSetColumn="CompComm" />
              <Mapping SourceColumn="ProducerComm" DataSetColumn="ProducerComm" />
              <Mapping SourceColumn="CompCommPerc" DataSetColumn="CompCommPerc" />
              <Mapping SourceColumn="ProducerCommPerc" DataSetColumn="ProducerCommPerc" />
              <Mapping SourceColumn="TransDate" DataSetColumn="TransDate" />
              <Mapping SourceColumn="SavedDate" DataSetColumn="SavedDate" />
              <Mapping SourceColumn="SavedUser" DataSetColumn="SavedUser" />
              <Mapping SourceColumn="ApprovedDate" DataSetColumn="ApprovedDate" />
              <Mapping SourceColumn="ApprovedUser" DataSetColumn="ApprovedUser" />
              <Mapping SourceColumn="Department" DataSetColumn="Department" />
              <Mapping SourceColumn="Done" DataSetColumn="Done" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Policies" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Policies" msprop:Generator_UserDSName="Policies">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Policies" msprop:Generator_TableClassName="PoliciesDataTable" msprop:Generator_RowEvArgName="PoliciesRowChangeEvent" msprop:Generator_TableVarName="tablePolicies" msprop:Generator_TablePropName="_Policies" msprop:Generator_RowDeletingName="PoliciesRowDeleting" msprop:Generator_RowChangingName="PoliciesRowChanging" msprop:Generator_RowDeletedName="PoliciesRowDeleted" msprop:Generator_RowEvHandlerName="PoliciesRowChangeEventHandler" msprop:Generator_RowChangedName="PoliciesRowChanged" msprop:Generator_UserTableName="Policies" msprop:Generator_RowClassName="PoliciesRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SNo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSNo" msprop:Generator_ColumnPropNameInRow="SNo" msprop:Generator_ColumnPropNameInTable="SNoColumn" msprop:Generator_UserColumnName="SNo" type="xs:long" />
              <xs:element name="PESno" msprop:Generator_ColumnVarNameInTable="columnPESno" msprop:Generator_ColumnPropNameInRow="PESno" msprop:Generator_ColumnPropNameInTable="PESnoColumn" msprop:Generator_UserColumnName="PESno" type="xs:long" minOccurs="0" />
              <xs:element name="PESSNo" msprop:Generator_ColumnVarNameInTable="columnPESSNo" msprop:Generator_ColumnPropNameInRow="PESSNo" msprop:Generator_ColumnPropNameInTable="PESSNoColumn" msprop:Generator_UserColumnName="PESSNo" type="xs:long" minOccurs="0" />
              <xs:element name="ClientNo" msprop:Generator_ColumnVarNameInTable="columnClientNo" msprop:Generator_ColumnPropNameInRow="ClientNo" msprop:Generator_ColumnPropNameInTable="ClientNoColumn" msprop:Generator_UserColumnName="ClientNo" type="xs:long" minOccurs="0" />
              <xs:element name="ClientName" msprop:Generator_ColumnVarNameInTable="columnClientName" msprop:Generator_ColumnPropNameInRow="ClientName" msprop:Generator_ColumnPropNameInTable="ClientNameColumn" msprop:Generator_UserColumnName="ClientName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Producer" msprop:Generator_ColumnVarNameInTable="columnProducer" msprop:Generator_ColumnPropNameInRow="Producer" msprop:Generator_ColumnPropNameInTable="ProducerColumn" msprop:Generator_UserColumnName="Producer" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccNo" msprop:Generator_ColumnVarNameInTable="columnAccNo" msprop:Generator_ColumnPropNameInRow="AccNo" msprop:Generator_ColumnPropNameInTable="AccNoColumn" msprop:Generator_UserColumnName="AccNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PolicyNo" msprop:Generator_ColumnVarNameInTable="columnPolicyNo" msprop:Generator_ColumnPropNameInRow="PolicyNo" msprop:Generator_ColumnPropNameInTable="PolicyNoColumn" msprop:Generator_UserColumnName="PolicyNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndorsNo" msprop:Generator_ColumnVarNameInTable="columnEndorsNo" msprop:Generator_ColumnPropNameInRow="EndorsNo" msprop:Generator_ColumnPropNameInTable="EndorsNoColumn" msprop:Generator_UserColumnName="EndorsNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndorsType" msprop:Generator_ColumnVarNameInTable="columnEndorsType" msprop:Generator_ColumnPropNameInRow="EndorsType" msprop:Generator_ColumnPropNameInTable="EndorsTypeColumn" msprop:Generator_UserColumnName="EndorsType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InsurComp" msprop:Generator_ColumnVarNameInTable="columnInsurComp" msprop:Generator_ColumnPropNameInRow="InsurComp" msprop:Generator_ColumnPropNameInTable="InsurCompColumn" msprop:Generator_UserColumnName="InsurComp" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IssueDate" msprop:Generator_ColumnVarNameInTable="columnIssueDate" msprop:Generator_ColumnPropNameInRow="IssueDate" msprop:Generator_ColumnPropNameInTable="IssueDateColumn" msprop:Generator_UserColumnName="IssueDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ClassName" msprop:Generator_ColumnVarNameInTable="columnClassName" msprop:Generator_ColumnPropNameInRow="ClassName" msprop:Generator_ColumnPropNameInTable="ClassNameColumn" msprop:Generator_UserColumnName="ClassName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InterestInsur" msprop:Generator_ColumnVarNameInTable="columnInterestInsur" msprop:Generator_ColumnPropNameInRow="InterestInsur" msprop:Generator_ColumnPropNameInTable="InterestInsurColumn" msprop:Generator_UserColumnName="InterestInsur" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PeriodFrom" msprop:Generator_ColumnVarNameInTable="columnPeriodFrom" msprop:Generator_ColumnPropNameInRow="PeriodFrom" msprop:Generator_ColumnPropNameInTable="PeriodFromColumn" msprop:Generator_UserColumnName="PeriodFrom" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PeriodTo" msprop:Generator_ColumnVarNameInTable="columnPeriodTo" msprop:Generator_ColumnPropNameInRow="PeriodTo" msprop:Generator_ColumnPropNameInTable="PeriodToColumn" msprop:Generator_UserColumnName="PeriodTo" type="xs:dateTime" minOccurs="0" />
              <xs:element name="RenewDate" msprop:Generator_ColumnVarNameInTable="columnRenewDate" msprop:Generator_ColumnPropNameInRow="RenewDate" msprop:Generator_ColumnPropNameInTable="RenewDateColumn" msprop:Generator_UserColumnName="RenewDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PaidAmount" msprop:Generator_ColumnVarNameInTable="columnPaidAmount" msprop:Generator_ColumnPropNameInRow="PaidAmount" msprop:Generator_ColumnPropNameInTable="PaidAmountColumn" msprop:Generator_UserColumnName="PaidAmount" type="xs:double" minOccurs="0" />
              <xs:element name="SumInsur" msprop:Generator_ColumnVarNameInTable="columnSumInsur" msprop:Generator_ColumnPropNameInRow="SumInsur" msprop:Generator_ColumnPropNameInTable="SumInsurColumn" msprop:Generator_UserColumnName="SumInsur" type="xs:double" minOccurs="0" />
              <xs:element name="TotalPremium" msprop:Generator_ColumnVarNameInTable="columnTotalPremium" msprop:Generator_ColumnPropNameInRow="TotalPremium" msprop:Generator_ColumnPropNameInTable="TotalPremiumColumn" msprop:Generator_UserColumnName="TotalPremium" type="xs:double" minOccurs="0" />
              <xs:element name="NetPremium" msprop:Generator_ColumnVarNameInTable="columnNetPremium" msprop:Generator_ColumnPropNameInRow="NetPremium" msprop:Generator_ColumnPropNameInTable="NetPremiumColumn" msprop:Generator_UserColumnName="NetPremium" type="xs:double" minOccurs="0" />
              <xs:element name="CompComm" msprop:Generator_ColumnVarNameInTable="columnCompComm" msprop:Generator_ColumnPropNameInRow="CompComm" msprop:Generator_ColumnPropNameInTable="CompCommColumn" msprop:Generator_UserColumnName="CompComm" type="xs:double" minOccurs="0" />
              <xs:element name="ProducerComm" msprop:Generator_ColumnVarNameInTable="columnProducerComm" msprop:Generator_ColumnPropNameInRow="ProducerComm" msprop:Generator_ColumnPropNameInTable="ProducerCommColumn" msprop:Generator_UserColumnName="ProducerComm" type="xs:double" minOccurs="0" />
              <xs:element name="CompCommPerc" msprop:Generator_ColumnVarNameInTable="columnCompCommPerc" msprop:Generator_ColumnPropNameInRow="CompCommPerc" msprop:Generator_ColumnPropNameInTable="CompCommPercColumn" msprop:Generator_UserColumnName="CompCommPerc" type="xs:double" minOccurs="0" />
              <xs:element name="ProducerCommPerc" msprop:Generator_ColumnVarNameInTable="columnProducerCommPerc" msprop:Generator_ColumnPropNameInRow="ProducerCommPerc" msprop:Generator_ColumnPropNameInTable="ProducerCommPercColumn" msprop:Generator_UserColumnName="ProducerCommPerc" type="xs:double" minOccurs="0" />
              <xs:element name="TransDate" msprop:Generator_ColumnVarNameInTable="columnTransDate" msprop:Generator_ColumnPropNameInRow="TransDate" msprop:Generator_ColumnPropNameInTable="TransDateColumn" msprop:Generator_UserColumnName="TransDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SavedDate" msprop:Generator_ColumnVarNameInTable="columnSavedDate" msprop:Generator_ColumnPropNameInRow="SavedDate" msprop:Generator_ColumnPropNameInTable="SavedDateColumn" msprop:Generator_UserColumnName="SavedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="SavedUser" msprop:Generator_ColumnVarNameInTable="columnSavedUser" msprop:Generator_ColumnPropNameInRow="SavedUser" msprop:Generator_ColumnPropNameInTable="SavedUserColumn" msprop:Generator_UserColumnName="SavedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApprovedDate" msprop:Generator_ColumnVarNameInTable="columnApprovedDate" msprop:Generator_ColumnPropNameInRow="ApprovedDate" msprop:Generator_ColumnPropNameInTable="ApprovedDateColumn" msprop:Generator_UserColumnName="ApprovedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ApprovedUser" msprop:Generator_ColumnVarNameInTable="columnApprovedUser" msprop:Generator_ColumnPropNameInRow="ApprovedUser" msprop:Generator_ColumnPropNameInTable="ApprovedUserColumn" msprop:Generator_UserColumnName="ApprovedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Department" msprop:Generator_ColumnVarNameInTable="columnDepartment" msprop:Generator_ColumnPropNameInRow="Department" msprop:Generator_ColumnPropNameInTable="DepartmentColumn" msprop:Generator_UserColumnName="Department" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Done" msprop:Generator_ColumnVarNameInTable="columnDone" msprop:Generator_ColumnPropNameInRow="Done" msprop:Generator_ColumnPropNameInTable="DoneColumn" msprop:Generator_UserColumnName="Done" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Policies" />
      <xs:field xpath="mstns:SNo" />
    </xs:unique>
  </xs:element>
</xs:schema>